UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BsUyIKPEU5ituiJXQN5XjJK+3YG7AznTYxAuLkK49A8='
WHERE
key_id = 'd0d1477d6f95510ae6d1dbf72c22688950c9251e22fcc6fb11a9bc5c4c590371'
AND (
token = 'BsUyIKPEU5ituiJXQN5XjJK+3YG7AznTYxAuLkK49A8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)