UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pQK9z6AHIi46zsJM8eNFgaL1DQ29jajyQr8EXopj6xo='
WHERE
key_id = '92b9fd9c930ac71aeffb3f3d108461f7d8fe6732121ce0cad023da1816eecce2'
AND (
token = 'pQK9z6AHIi46zsJM8eNFgaL1DQ29jajyQr8EXopj6xo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)