UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CTB5hxkN+Tp9lpA3ZXeL0a6c876bIyGrbqr8jZcrZgU='
WHERE
key_id = 'c58c3aaa21fc747df374ffb6ce446315ea8f42af2a0df566539dcaf3efed9b5b'
AND (
token = 'CTB5hxkN+Tp9lpA3ZXeL0a6c876bIyGrbqr8jZcrZgU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)