UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cEu3LqoLY3We/yH9cbBz29WxhEEXB6teCg6sbevmFP8='
WHERE
key_id = 'd4aea58d649f19950e21ccc836c7bbe1fee8ada8164994ab28ed90a7ad45bdbc'
AND (
token = 'cEu3LqoLY3We/yH9cbBz29WxhEEXB6teCg6sbevmFP8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)