UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6vzKCxAZ1QTvGKWwwirAt1MZ4/JSK2kcYD9TCqXFr6s='
WHERE
key_id = 'c204c206c676b57fa259f3777c6de611e9e1ac6b49cf289f68cbe0ec71d902b1'
AND (
token = '6vzKCxAZ1QTvGKWwwirAt1MZ4/JSK2kcYD9TCqXFr6s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)