UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '20ZfjP0US1OUvKA9HmyspjmfqYxECQceBBPKNw/4eDk='
WHERE
key_id = '9a55faed31774c91cbbd9b4cf073bfb6b74ffb37bf39b4f402331d435de5dd9e'
AND (
token = '20ZfjP0US1OUvKA9HmyspjmfqYxECQceBBPKNw/4eDk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)