UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'eRCRDa9NTiNnlfGDrRFIt9M38lBtc9OV+/LztD+jfkE='
WHERE
key_id = 'ce9e5cbdd8dff484b1c6bfdf4f372f6d090d57cd8b80edf020c5f1d3abb06efb'
AND (
token = 'eRCRDa9NTiNnlfGDrRFIt9M38lBtc9OV+/LztD+jfkE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)