UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9Sv2h8P6JmZ7ekzeL61RTxHcl0doR9DisUa4A8ZguFk='
WHERE
key_id = 'bc71a66a8327e61a4ff32028d8b4bbd281bdd16fc37f646233fe381152396584'
AND (
token = '9Sv2h8P6JmZ7ekzeL61RTxHcl0doR9DisUa4A8ZguFk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)