UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BL+5NkoQHMTRe99L1S4k2soS6vT78xcG8DwtgmzqY4k='
WHERE
key_id = '47244bb657eeb9af5f96e2e7ba12be9d9e7a2b583e2b4eb6e5f4c34c4522f7cb'
AND (
token = 'BL+5NkoQHMTRe99L1S4k2soS6vT78xcG8DwtgmzqY4k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)