UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZnD4AcFzGyKHxw2eLobCYcJG4FXmwz5G72DbdMN1/pU='
WHERE
key_id = '18e3ec5d0521c005564b2f53b30dd8c4f2535d012a64bdb539e144abe975eea7'
AND (
token = 'ZnD4AcFzGyKHxw2eLobCYcJG4FXmwz5G72DbdMN1/pU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)