UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6TBVL9yPmjBlK8KBX8DGT/8CA8jz5LPsdRFITtLVrHk='
WHERE
key_id = 'a9f62faf91c5c64d7b00f7848d9fae72ebd43408554d1ea4a4b9791a64da54b4'
AND (
token = '6TBVL9yPmjBlK8KBX8DGT/8CA8jz5LPsdRFITtLVrHk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)