UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5C9x7YV61y9ntmKpKfX/zUoi17LbO7SpSYaDlivuEqk='
WHERE
key_id = '8a47db594dccda986d6761dfce7b8e9f0963151e148fe3b77e30e80d25f424bc'
AND (
token = '5C9x7YV61y9ntmKpKfX/zUoi17LbO7SpSYaDlivuEqk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)