UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0i8L0ekS/CXJWkhO71/UxDp75QudDzGzBtn8vEmo2FM='
WHERE
key_id = 'e9234dffe997564d1b79a6411bb16330a95e2083c504384f97b048a4cb700195'
AND (
token = '0i8L0ekS/CXJWkhO71/UxDp75QudDzGzBtn8vEmo2FM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)