UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6ms4DKf2qO36NqkHHZPgAeEjIcSpjdjwpGLuLX4gojo='
WHERE
key_id = '69f41ebae212db4a14bbd09aa679b77389cf81280a2e61bb88a9c0160d6d3c2e'
AND (
token = '6ms4DKf2qO36NqkHHZPgAeEjIcSpjdjwpGLuLX4gojo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)