UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'l8gBTgzwdYIevPPwU6fecM11jlQ4FYqjnlEW1w1oLfc='
WHERE
key_id = '3484b7532b94f746a5fe774f37dd12163ca80ff24d77d7103459f66b3a9d307b'
AND (
token = 'l8gBTgzwdYIevPPwU6fecM11jlQ4FYqjnlEW1w1oLfc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)