UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cx0zSQ4LxvpOMNT/kzXpsIcBWlW170Z6RkJRjJFg488='
WHERE
key_id = '71bffe387ead140a57a416b71a45b0e7b9fc3f5aeb1b46799b49813cfc19cc46'
AND (
token = 'cx0zSQ4LxvpOMNT/kzXpsIcBWlW170Z6RkJRjJFg488='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)