UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8FX8BCVtf1Gx1Dsur/IcqAA0GMTy64xlvTQxrOELRCg='
WHERE
key_id = 'b55c402e662781d065bf40e8f6f38622e5e5c98c0204a02e78e37b41aa8578fa'
AND (
token = '8FX8BCVtf1Gx1Dsur/IcqAA0GMTy64xlvTQxrOELRCg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)