UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1sIZp6PtCTscWaHFoOe4IMLGJoXOjb99KkTURfixjig='
WHERE
key_id = '863e278365e7d480e38c03067b2602c047fe23ccaa3e1a6e70e2eefd9b695a25'
AND (
token = '1sIZp6PtCTscWaHFoOe4IMLGJoXOjb99KkTURfixjig='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)