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