UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Idt+5TVQdwNlTd9lolx4CKTnFBF1vJVpPrhiEqxUEF8='
WHERE
key_id = '6567e24d04eaa309930d5a7a75d74d03bdd93616e26c856a8e7002067eb1040a'
AND (
token = 'Idt+5TVQdwNlTd9lolx4CKTnFBF1vJVpPrhiEqxUEF8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)