UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BEL8++CjIsgnnO1AXYt5hBG11UFGZ0qh+xJrUG09jwo='
WHERE
key_id = 'cf6e4e9dfdfb494197019ca5dabf35d4fff179f788a0ff13f0ee3147a4928fee'
AND (
token = 'BEL8++CjIsgnnO1AXYt5hBG11UFGZ0qh+xJrUG09jwo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)