UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VWjDKodmqgc6NjpoiDUO+5CeG8s7zxUpOhH4qEflF/k='
WHERE
key_id = 'ec0462e7adc714dc31376142629f628e2a7a8a8980752208ffa8fb436e758007'
AND (
token = 'VWjDKodmqgc6NjpoiDUO+5CeG8s7zxUpOhH4qEflF/k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)