UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '528zWADAdoKhn8YIuEqJpgo5nAARKpguEE4KN7DTZMY='
WHERE
key_id = '9e4619e0d1160e362ecdab88fa34f12eb20de0a849b00bcf1a374058a64ce544'
AND (
token = '528zWADAdoKhn8YIuEqJpgo5nAARKpguEE4KN7DTZMY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)