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