UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'idQyoyhKUNLv/xnE8RBgaCVqv6a7ekzxdkjawKGnD00='
WHERE
key_id = 'a7875f5ff9272824102563aa13745f95c95a36dfa4bf8f1a88779810b2c93f25'
AND (
token = 'idQyoyhKUNLv/xnE8RBgaCVqv6a7ekzxdkjawKGnD00='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)