UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7KZbEJo8yRpVL0tU0dfWoEXCC+0E0NWjpD40dRCmYLU='
WHERE
key_id = '9a746bed64fa616ea87c5dc1f7a9dc7b5c1893e92a32bcdbadb38b2a086f907b'
AND (
token = '7KZbEJo8yRpVL0tU0dfWoEXCC+0E0NWjpD40dRCmYLU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)