UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VmVCTGAVspcy1Fxi1YeQdoXekl1sDA3EHxy6gM4FMSs='
WHERE
key_id = '80d4520e984f7e06c167457900d4a2a275d3c3e0fcf1d70f5a4e38e35007436e'
AND (
token = 'VmVCTGAVspcy1Fxi1YeQdoXekl1sDA3EHxy6gM4FMSs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)