UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EP9yob4uG/LE67AWo5VmqcR2eP8I18UDGA4ZXb96EkY='
WHERE
key_id = 'd2905ab7d14cd3e301280a4f5537a6efc7a52d7912d09ded5bf08de57e42ca84'
AND (
token = 'EP9yob4uG/LE67AWo5VmqcR2eP8I18UDGA4ZXb96EkY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)