UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1Z6zp0FSPmnw4upckP7+wB8h564tCHtKAq9MIm6Mq18='
WHERE
key_id = '9bce418f8f3d77630de74aa84a3897d5b55a7906fa9f9d591c03efe91fa7d106'
AND (
token = '1Z6zp0FSPmnw4upckP7+wB8h564tCHtKAq9MIm6Mq18='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)