UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8znQBlqVZ/8YzsvyvtTG/mg6cDHnyAYF8CoL6v1ZBuA='
WHERE
key_id = 'e329f896027eff831847bece8a57fa08d5aca1f20f729e928f495831f78f97e7'
AND (
token = '8znQBlqVZ/8YzsvyvtTG/mg6cDHnyAYF8CoL6v1ZBuA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)