UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qeNzxoOKldeyR+FH0KihIGzAZFQmzLDY23mjk/rfRCQ='
WHERE
key_id = '21723b78091f3b67c6b1cd52f5982069e6dc451b6669c0cacd616738f3fa4410'
AND (
token = 'qeNzxoOKldeyR+FH0KihIGzAZFQmzLDY23mjk/rfRCQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)