UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0WsRl8dl30Jimd8qH83/wkd+jjSZMMAN8XjST1esDOM='
WHERE
key_id = 'b64c797091bf7e26f75a6ad7fa305e90d417e87ffd42e8e44df87a83ec71d62a'
AND (
token = '0WsRl8dl30Jimd8qH83/wkd+jjSZMMAN8XjST1esDOM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)