UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'U0uiVBkIBmFWMkSDLA414mf1fpVadvH5HR+G8S+3NPM='
WHERE
key_id = 'c9bc6a6aa6fe48c62d3898a3c3d76c6c78206f2b701da1729cd48dc787e4ef78'
AND (
token = 'U0uiVBkIBmFWMkSDLA414mf1fpVadvH5HR+G8S+3NPM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)