UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BYaiB0acHdyxe5J1KufswCRBioVWHxQda7UKYNiRMoE='
WHERE
key_id = 'b269e9557ac5ef8f915f8a4ea41dc7662432fe1ee103f020d1daffa308937fbd'
AND (
token = 'BYaiB0acHdyxe5J1KufswCRBioVWHxQda7UKYNiRMoE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)