UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'brJPl4zMV9sU6/huBi456ACnyIPlMBedZm4rr51gbko='
WHERE
key_id = '6292cd5662178b673afe97cc3ff4b8366d95bdb63adb0e90a3fa4f2b7c2c3a11'
AND (
token = 'brJPl4zMV9sU6/huBi456ACnyIPlMBedZm4rr51gbko='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)